import xlrd
import xlwt


def allSheetsToOne(src_file, dst_file, sheet_name="all"):
    xlsx_src = xlrd.open_workbook(xlsx_path)
    xlsx_dst = xlwt.Workbook(encoding='utf-8')
    sheet_dst = xlsx_dst.add_sheet(sheet_name, cell_overwrite_ok=True)
    row_index = 0
    for sheet in xlsx_src.sheets():
        for row_num in range(sheet.nrows):
            row = sheet.row_values(row_num)
            row_index += 1
            for cell in range(len(row)):
                print(row_num, cell, row[cell])
                sheet_dst.write(row_index, cell, str(row[cell]))
    xlsx_dst.save(xlsx_dst_path)

